SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583158 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583158 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616766,166854,201407,73080,537132,418594,451940,288654,361878,103741,521025,881627,436011,717716,850372,455985,309786,559306,165624,481064,739158,635049,740002,852661,161816,830211,366154,252439,789288,715962,510767,918426,783,443410,591413,547839,232630,456861,799337,626867,296645,1018919,1043523,308604,8495,18921,576752,906903,520038,191814,431816,409350,194698,186840,220182,276499,173340,782886,369124,803703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]