SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 758909 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 758909 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99139,1039413,757307,551488,604740,492963,765520,812055,701464,715180,976336,252526,282660,845354,201474,108777,464056,274798,849665,671011,802174,1029865,935683,435570,189735,152795,1019706,940194,948004,752642,525381,626387,118200,182992,7385,113093,612047,94617,71987,464198,105765,566955,216619,760201,44836,33813,754012,600952,550586,672198,1043792,988843,129768,124025,921145,201684,465120,1034838,543357,920073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 758909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 758909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]