SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305551 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305551 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44233,424391,127470,133810,224459,584149,981588,147795,708866,590896,795149,867817,704761,87507,787311,244846,549755,999188,464853,946325,164664,610657,554300,512833,406353,422316,514005,763935,353033,531234,568339,635756,340434,118730,226453,1030492,762710,564676,595183,901151,262163,558303,560921,633010,901765,525818,704768,491344,386842,236704,925328,171135,452647,336402,356460,790276,320569,97013,444972,543809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]