SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42015 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42015 [ RunTime:0.004857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543603,780228,433561,188432,213559,963270,38260,384567,257467,474452,1024336,547347,1013571,875255,758632,744214,254638,798917,569618,179127,667,288010,749645,867071,1042967,921099,626345,1038484,333350,901781,438817,559039,627087,794577,474674,684894,722086,453069,256915,135110,278301,737619,620551,426756,130443,869019,474998,307515,561210,345363,338462,758878,680583,602363,248550,390354,322465,889085,703634,753231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]