SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301611 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301611 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890409,958173,324082,341793,1011308,349034,593974,42549,263136,855310,170105,1005541,398859,56975,735841,712347,208844,748216,405648,17462,513476,1006890,315369,545595,146529,1020162,417077,942274,591936,423239,182925,954755,948749,457069,881825,625482,702706,73434,475803,327159,233639,897035,671123,66011,697089,466316,1002230,840805,495172,208881,202828,550359,344699,541180,107648,774637,336249,141877,983757,440709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]