SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145698 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145698 [ RunTime:0.003444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416382,130365,508104,292187,1047012,351163,925810,168117,40334,616877,578045,773282,427855,1013607,393219,748106,688318,180111,226986,787157,1039846,434770,266247,251302,1026102,754663,240773,968902,930567,672778,110430,128543,531377,1048091,50180,990361,42247,108584,18485,84376,122570,229296,294498,948790,990409,141562,992677,736069,711892,973037,1005007,872704,117358,304476,668662,998803,470604,320387,708304,196313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]