SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291142 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291142 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289543,111718,101528,702549,718145,463804,469008,821911,214583,475521,64630,82071,788324,569441,960137,156305,167553,489030,18554,674773,949287,418553,28249,197766,847012,672737,495560,1027136,696885,808530,447354,1013,48679,984445,562727,972214,234940,462774,21258,713790,379226,188727,775506,885862,419535,183529,646432,501438,905565,992236,404649,49421,917762,817512,483253,675988,930958,437162,323323,201982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]