SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804317 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804317 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917004,658810,88784,711206,965914,370950,256614,501199,184477,367581,459551,805247,507609,1028316,1034128,951813,622954,172160,715491,799776,304556,254646,251307,443236,572293,190835,414983,407411,157650,941906,322519,507797,838213,802800,747665,969548,1029512,844535,269356,248133,995571,293611,377857,74330,335183,842971,244399,825309,770631,648186,35318,440502,85953,1015532,122197,273054,730066,871265,567309,684728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]