SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104194 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104194 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10664,440312,304389,202608,818326,720041,585819,570335,228906,609046,287815,455485,388660,301965,276945,1043262,42894,554678,1182,612791,923992,898801,472604,740867,291975,860797,191832,633674,536784,918563,961469,395393,115448,471954,187609,343135,39023,693923,483676,185463,286317,146640,171965,252162,839888,671512,615590,394023,570851,755837,155046,877875,688371,836059,383463,175801,906116,1028725,153741,57479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]