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` = 455288 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455288 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222919,409794,329138,75094,300025,381653,99008,356305,1004043,716945,646768,151616,937464,367596,241424,304404,43989,1036989,943709,500086,979806,159036,1026172,680058,374151,713140,16694,835001,64843,1021970,587633,668126,740888,690637,45699,340277,819075,937236,21843,766772,754617,272307,862838,539440,661064,1040076,832726,50358,514636,655814,641682,1028673,195345,648082,693362,222678,109200,627613,820011,91793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]