SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004828s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456380 LIMIT 1 [ RunTime:0.001080s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456380 [ RunTime:0.003075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510856,371310,361088,805451,609355,378866,106649,827006,163175,3361,1013370,454968,321003,387174,43355,30375,950228,500958,791714,318167,601630,320840,841979,223761,918101,591699,359708,349482,287151,868,331033,890137,40097,688276,852280,297321,726755,118246,900965,123501,303865,608359,906859,498428,782327,230758,454785,1004238,644064,224159,604984,401472,695293,369851,692121,713632,463647,6458,528131,193020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]