SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620545 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620545 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12424,448949,274739,155288,890281,680649,263939,646616,455648,915063,401380,732614,662672,734001,931096,303813,473867,399717,369577,422414,592805,380208,729406,669947,183075,77703,364342,994009,157925,316711,1028937,385193,627553,878153,620957,27329,421571,688656,348884,642940,278938,754058,885210,188653,1033655,38683,129271,84734,905915,231927,850762,65181,574571,634589,758685,100105,156470,1026030,443726,336114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]