SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542692 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542692 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518936,352836,971867,523394,747682,906857,958918,835024,211655,4867,790313,888979,67701,182129,719275,668298,885178,696734,1000019,1047610,511334,173329,315677,952373,379200,392934,262269,750704,804393,994082,54142,487465,734071,12375,299730,555040,27195,960073,914983,860838,182021,396538,404295,743610,344916,491757,583200,650613,485544,343919,470010,698168,7187,495043,341325,742825,241847,27252,765190,269606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]