SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002914 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002914 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933510,667598,319789,147276,697693,1033272,439690,473091,840009,3943,621320,418491,223833,569681,914883,547651,145358,646394,381700,962830,654038,450727,384762,959463,132575,634587,435134,957732,1035534,313274,374334,628577,445661,774962,388990,542205,533548,305930,178287,707185,172670,331756,1014459,156218,10861,536242,300226,805413,95414,589897,390881,1016681,188463,812605,20973,50854,646783,483661,469677,243345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001313s ]