SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583380 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583380 [ RunTime:0.002896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185316,475011,72127,1939,538995,1031515,219097,970330,149451,15960,513229,1027772,224540,824230,134966,823739,553602,766352,630455,250252,759126,464332,1006597,985557,697365,31441,1041974,829375,458169,677976,458663,753094,983751,525973,491030,878199,223031,199911,211952,44651,558069,563852,366248,993328,641174,976095,523243,1017454,615211,462846,396003,680521,523791,209817,789025,321229,118662,73503,620592,147199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000946s ]