SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535310 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535310 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884444,495387,792864,625034,624482,187366,426348,568644,436892,452456,878562,397884,327665,829353,572447,229633,986237,715722,775351,946560,528222,869704,183351,926862,322070,114084,1007921,53129,864863,635751,994163,404832,522980,554655,286933,735374,514773,257350,1024121,646091,785091,645095,975917,206377,45879,844582,71472,461299,311689,250714,389602,199501,966680,645462,765715,64207,381207,612056,956499,87070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]