SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519681 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519681 [ RunTime:0.003296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202912,831621,994861,263836,405820,653028,94732,76867,692735,63221,439385,413759,634374,471896,16042,533522,551132,1029180,255921,902680,107015,265135,65527,465167,110488,65613,46445,328326,70254,799117,355411,115909,918144,350451,533678,1000992,71096,773436,792039,33131,57154,159286,914184,121169,37081,986715,326731,45641,643131,113090,1009497,496171,316227,84395,651491,298072,456495,742927,973299,934592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]