SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47148 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47148 [ RunTime:0.004443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364463,715396,685611,870858,677629,443060,678833,130756,1010296,236480,432408,402337,927964,864893,144003,223284,335441,904574,915831,631730,521905,313868,748685,86038,184447,215377,895606,272730,501935,810616,208964,271621,691065,1001571,732373,53670,277733,405388,894454,810519,530800,393830,913613,302643,178829,397161,133823,337548,458302,486488,614336,40944,384986,32718,584292,573379,993531,972332,591931,217587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000951s ]