SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104702 LIMIT 1 [ RunTime:0.001638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104702 [ RunTime:0.003903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335654,415271,925638,484915,513150,659248,561055,406973,435956,957633,417671,522215,497223,760388,896311,955599,282716,63048,956749,168576,361182,997650,672837,66291,544497,305263,142187,761125,49334,971359,40869,696779,372923,610687,1024678,348764,350746,300016,296235,595327,779963,256947,85350,811597,603380,759674,224620,415302,627230,328870,1025995,1004434,873882,153645,328336,1020940,425218,194768,168818,597057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001446s ]