SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106292 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106292 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791954,139696,462773,850601,189678,584864,43136,912261,361721,608239,415840,148388,188908,490032,401398,738139,800753,835117,288728,494966,639094,914808,272242,575963,998546,491262,343148,33666,1009541,505775,907059,493455,595830,491908,161352,1022641,820402,3604,118456,381071,134401,250515,936080,743637,592720,1019597,225503,304646,998798,207132,70937,81103,810122,733633,284808,892561,445567,613263,946700,939260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]