SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378818 LIMIT 1 [ RunTime:0.000823s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378818 [ RunTime:0.005428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516030,476243,74794,81969,695610,963315,152914,889915,345880,719529,770716,141657,699460,236375,340657,503934,1012695,2513,878286,778781,910017,759146,747402,676654,565231,25014,620749,224328,570848,176638,479872,915782,112356,481033,1014124,32465,235680,870347,399836,697193,506197,358846,137469,76710,80349,499280,742713,82662,713357,948071,373526,871827,392936,582765,744271,573164,395764,149874,928997,92997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]