SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480171 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480171 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298904,1021799,564683,674397,615006,964448,432393,762845,457023,1030806,652845,200077,830656,986378,931624,235092,118693,324910,740091,741067,854783,815335,922654,1036787,889956,31404,246778,366660,667635,253062,885305,1006980,851494,715012,656953,442160,620336,210602,170944,1006061,1032992,44399,975940,686233,721272,152067,317476,763183,558603,989829,754874,946493,79882,861175,337075,37736,539911,129467,491521,633928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]