SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134107 LIMIT 1 [ RunTime:0.003626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134107 [ RunTime:0.004582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2002,867118,478124,161021,754293,1002987,161580,948218,530505,173676,958071,381565,384232,686978,960488,851625,779716,815228,166494,541983,936502,662814,432194,171561,448167,515214,199851,346463,463608,512256,288157,644487,673291,953749,872821,695963,419364,696395,230594,229609,254872,752813,320799,584233,194776,663367,614339,3103,712930,432000,156666,829981,328032,32479,526413,206494,254921,776289,609974,1005091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]