SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506301 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506301 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422821,430828,829682,934730,864386,706692,120009,666456,27691,406633,496982,191305,991703,887367,128254,955965,805221,304101,146600,719194,905032,220458,38431,250639,173250,691393,591674,234965,237364,56655,422587,163520,593491,379157,731774,53086,501107,628497,761142,984459,223245,246075,99987,621480,125355,62053,483999,882480,210052,44866,130798,178017,312733,146832,454568,512264,424345,590664,537088,342469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]