SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314388 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314388 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520038,499571,875267,550753,174396,642252,965410,114430,409415,388493,859483,244976,424545,511537,444944,49168,320939,371882,672353,246107,328574,246728,94197,515741,517776,659188,357178,610108,1022903,312380,479448,535337,140923,382650,695323,461841,369869,721467,1007009,245788,545882,796296,385507,261065,352818,1000711,620809,54318,446853,758660,937233,703146,356508,726807,181822,270383,718240,619101,693780,1028244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]