SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585004 LIMIT 1 [ RunTime:0.000795s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585004 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014499,916335,403644,600931,142523,3398,382667,481960,516594,500986,183013,1007935,166522,523140,553010,441613,848092,218148,917167,129464,406335,322504,505115,341303,744631,931380,259258,902143,1030060,169805,1026120,543928,862191,708873,582534,320847,890701,271168,797031,645825,372890,201582,90967,106503,752081,537930,995439,523846,54876,295188,1029593,804400,943022,123516,761654,877137,882247,1019389,863383,325725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]