SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480149 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480149 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510288,1044397,999315,813190,487873,719195,118559,513417,918541,795383,863509,732362,736081,829290,624525,562321,285502,516553,156284,184492,914763,948920,300716,835768,746543,900294,110160,680480,627410,105195,379551,1003571,507799,982636,255690,80928,435403,168421,1029041,979842,881384,443743,135493,618589,327167,106436,800402,326491,262482,674279,1024138,720338,566062,805639,394652,263325,692828,924773,573889,521675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]