SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326033 LIMIT 1 [ RunTime:0.000600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326033 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4361,845724,866519,150690,118780,533919,196967,945639,817633,201212,967001,496481,1018063,732929,219798,277576,800964,668162,755004,49667,667757,639265,513406,944228,742065,686435,250605,671107,896481,142454,917830,272805,771410,886574,718931,402369,1038655,512355,586940,405008,387330,576560,460859,231992,824563,470742,78458,713708,854746,1043854,338120,503645,545889,1590,915979,356517,775701,682009,636973,418880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]