SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387699 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387699 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336174,831465,463914,589137,1046411,418357,998664,655719,394869,143575,240214,494625,659227,387640,491603,550500,89035,760784,34024,349642,294652,438601,60757,687099,192869,262517,666325,498713,259567,316486,422771,661269,572170,411560,379803,550616,589945,392772,282383,711748,320344,628437,434856,166142,1035551,194989,958451,638427,976901,475890,169674,264221,4206,476702,477049,176284,531593,1019032,895116,238506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]