SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597311 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597311 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58072,938757,3352,898169,726955,286044,244750,961348,84190,926004,851675,113994,286494,409707,216686,842306,832541,110558,23861,461643,442929,653256,1043425,763659,370261,541690,993213,912909,539514,194140,616477,133064,325349,477302,810524,1042824,146586,211362,312603,181353,865575,206359,963379,408536,89500,131699,763610,111771,1028722,356474,644312,449536,705258,172322,180200,169529,841710,512099,895638,122686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]