SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038394 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038394 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478622,986628,910954,226859,908354,299210,385714,1043231,757854,377540,796466,213897,465667,927201,256079,249943,844726,280694,325325,15732,35513,524993,3235,471826,775488,424840,968326,160970,803117,1019156,862693,110811,832085,375956,967491,458453,548533,252846,527193,511833,611166,304867,740798,458366,458125,210819,278615,906925,700240,1042746,290944,4274,167933,875720,872509,539595,717518,498013,399986,1031777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]