SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526330 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526330 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431204,401298,295201,740714,819079,1004314,38838,860722,265656,993325,132783,442673,1029607,305868,571865,235985,731204,837177,871263,422185,271435,798961,426693,888906,635262,352897,461446,283579,513454,91940,878288,370338,75280,1009311,430717,119183,121523,199330,77818,968039,269349,1044006,27789,618309,177707,310549,521826,536294,90869,765946,202012,252248,1026761,505878,738262,393555,624089,398731,346330,134703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]