SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804063 LIMIT 1 [ RunTime:0.001701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804063 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802915,668,821108,62592,725134,222692,242509,456975,497286,275961,973290,631817,187379,379934,319602,1016811,230629,285557,298298,281873,721293,125496,951707,13821,866510,500891,118119,264586,182182,85907,131925,811235,930290,772050,810147,644890,1027063,255628,856167,423589,974782,260314,71117,697681,695725,858773,555809,719630,591068,309315,736551,834986,278240,434872,535306,208166,1034371,997375,628852,140352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]