SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162517 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162517 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424821,653949,805636,1324,88113,108935,488066,885232,688453,678831,251983,81061,643002,588959,256249,353644,1047579,191792,287518,339416,916188,171588,300784,141086,349395,94259,130998,551797,534187,577740,849201,706056,400077,319653,669974,461838,74033,98179,486573,824004,780057,879718,438705,431618,838731,400232,811877,876611,575188,590512,695274,727249,71064,923553,156688,789377,65750,29903,1025217,853091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]