SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516218 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516218 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115131,797729,385530,953825,376825,540544,146508,970136,1047572,474474,415283,674598,8947,55027,639466,290295,1009377,644709,985055,778174,161880,51287,870863,438679,578841,261760,34009,231162,47123,495464,136078,830845,534176,826911,521561,356217,643248,954340,60449,249558,491993,473578,972071,656409,173403,46902,205201,268688,458451,393800,685328,513782,751366,613492,961649,768483,19177,400270,339199,595299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]