SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009514 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009514 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22618,605105,671359,440615,696099,453555,886424,899100,482358,492782,234526,823509,737884,411950,574443,544279,241180,3463,426283,125870,8774,562698,358856,434580,508176,329156,1040471,564088,422750,817034,804499,847736,642410,230220,812999,666215,259078,1007487,328906,52852,419369,864195,371318,607149,792702,77339,701712,473638,1018113,566896,931920,691406,694720,31860,1007316,133846,525609,469173,190847,98851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]