SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014446 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014446 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397292,233012,965698,511147,327508,630248,645394,523474,837049,658585,592111,449743,626207,458921,157168,813213,400012,198691,618272,526228,579128,634317,861958,501417,281408,991670,1005171,685340,548523,584819,633605,840481,182278,682626,205393,558336,998151,832187,367855,267555,417482,638722,605711,804841,723636,928857,741436,602517,696155,612774,303309,775460,266080,382879,494627,395371,763422,807133,728073,19382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]