SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001973s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153518 LIMIT 1 [ RunTime:0.001416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153518 [ RunTime:0.004410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511579,1029769,28256,528685,620095,460167,595808,467577,344997,827078,119732,858635,592401,395005,193532,630702,112573,481133,1029989,983525,274126,443956,46403,170908,510077,576708,97059,138339,493001,184230,799478,558553,24899,1004817,910738,1000155,126387,381719,768006,7877,226503,421790,311526,739756,171710,747723,341123,391979,657455,974555,453443,294657,551873,267614,468445,706397,894691,863782,832746,304941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004597s ]