SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483571 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483571 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531214,275716,712625,154462,53504,804560,766039,784399,606441,6199,1048668,744373,550569,327460,999965,209927,559197,621066,1036826,628319,635242,648435,775612,252174,369632,545997,876318,526411,51100,519561,925562,210448,307823,1027650,934101,613013,937519,962350,158806,589846,918906,871220,320840,1015726,130128,1010514,928701,547624,310089,573204,420121,1006099,986488,984430,520416,884363,834392,625244,37333,760579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]