SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344069 LIMIT 1 [ RunTime:0.001126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344069 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154532,611708,72292,620774,1042912,491448,92624,179665,357238,396579,406781,233573,540688,73721,194762,442891,75223,389460,965167,898796,999975,144633,819248,461298,394462,791091,222425,629619,1024671,73394,458369,467487,990808,164186,36451,355364,284872,62702,646966,787226,606291,868979,671337,416790,290176,647166,66447,992527,841937,642666,596011,182260,510668,664181,424656,80843,655144,984254,470767,774043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002079s ]