SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590291 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590291 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334445,52013,1020834,10239,532669,658565,510647,348745,518474,333003,462188,538067,997345,476677,748382,686297,979400,369000,83690,525456,149376,942825,469676,208520,468636,278827,571433,402324,757131,925806,516573,982304,605557,144814,706821,250823,110767,54473,699747,451790,798422,285687,804430,411668,68378,675967,1033244,803472,444356,867943,814666,63150,150614,628658,686215,896160,73344,42222,983716,49331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]