SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036398 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036398 [ RunTime:0.002293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200835,550310,807915,839954,385065,209689,130437,636535,795648,153503,1019175,727260,603745,641974,21277,67115,574761,945088,558192,897734,418867,1027524,206312,1005688,502477,890207,474792,17763,717401,1013755,235671,416759,241791,381849,662986,239329,649781,873864,983789,935991,24677,259164,427836,716470,773528,896189,811086,536795,650239,446670,979013,933076,332300,521788,158267,494915,86113,732634,1035739,184133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]