SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534073 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534073 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478958,331299,932083,29399,762175,999215,423881,725770,402638,1042322,363792,830431,113242,429407,924049,474328,745583,677149,503362,956113,890617,717611,873333,156038,108134,163244,440560,691270,240262,888783,11119,931163,6703,828678,226342,879329,218841,324861,119566,387127,829758,631197,634683,564267,239545,468435,328945,502305,317138,642279,664900,523991,360290,342189,669527,862229,635799,976927,248190,31612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]