SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435384 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435384 [ RunTime:0.003009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445281,784,524996,304316,75125,935437,403391,709457,846033,238699,1021624,201078,774070,818521,143587,310553,260283,913372,105547,1019226,648371,936221,302719,120910,947153,670096,20432,526356,27550,907767,396415,532309,827280,597196,617542,350500,375314,628049,147816,124027,443739,922032,891420,234943,141622,468814,121767,711737,826960,795391,481784,718794,121533,492821,1035985,557014,49381,120135,956213,386153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]