SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589916 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589916 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540511,481708,81878,602526,150960,698856,845418,989768,953948,289540,198382,128665,272395,312217,921342,976776,944158,39052,669597,541439,625888,15904,875954,56160,801666,824927,956532,372187,739199,502513,826702,256363,377102,658972,309763,716658,521513,488480,468822,241014,741568,313833,860282,593093,250274,493306,952239,164114,439051,828130,759751,817065,965840,848336,79762,790749,456703,810799,768900,59501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]