SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526178 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526178 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629032,73757,432459,359634,43547,905686,911025,917045,339407,844878,924775,317291,190105,556694,400784,830116,671650,939652,728457,994994,7325,236961,356408,1017620,100217,674504,1024727,49124,237109,498310,397275,213579,706557,407755,862317,200489,973430,697110,1003230,232152,311098,718942,797762,576138,627503,821573,451300,167256,840147,844925,1007545,789279,928137,696779,975583,639877,79607,386400,18411,876496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]