SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597913 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597913 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727845,3673,829019,3255,530526,1007335,401238,731125,174855,279636,598804,535870,671847,374336,814472,432792,683765,356844,378331,386588,17670,681241,411755,540200,847076,1017546,111612,1010140,555931,99438,934660,196793,203626,633231,559793,455117,843155,787877,1048621,399865,744890,19432,696259,80941,694427,885388,178813,545602,663445,775490,435141,114052,439240,284715,682974,570880,181138,224452,304154,75707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001105s ]