SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402666 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402666 [ RunTime:0.003095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890003,628661,234964,69275,16807,1039357,459211,540098,57176,516641,1023667,746371,267387,1039121,140525,919409,512136,513141,1010134,675834,870491,545014,193944,425256,522951,776489,316675,813565,525647,369544,1002809,1018215,11561,210984,978968,101450,1022658,754576,728492,1015595,873010,935659,554205,104842,568370,514735,1042149,939345,33987,794897,162104,993910,52986,497101,505759,892924,961721,53062,142026,744220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]