SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505353 LIMIT 1 [ RunTime:0.002429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505353 [ RunTime:0.002941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608016,861724,302060,75913,835674,195644,513520,205316,744960,855825,243719,505421,160199,969534,128743,270212,86798,554487,997635,1020233,833668,308833,611993,518393,895347,781003,557268,493410,38281,515176,499685,819199,713186,135087,26161,415101,839684,725302,133820,208299,866043,392103,283560,1021071,868224,521913,574826,12994,506062,947714,29838,158037,60712,930126,654476,59168,740236,693033,687697,608554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]