SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001754 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001754 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707570,207401,104665,1004219,950983,620449,861282,700245,145486,111803,542851,860059,649117,848556,770334,930044,647027,570931,661907,831207,737411,832618,394620,53498,352547,69731,284673,58031,420028,68096,552699,185017,56517,486425,482185,849668,16367,281244,319239,622007,543569,571077,152944,713850,442600,680083,1046496,129345,691980,418070,1037354,645618,107999,457472,354819,795257,891709,864886,216049,530562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]