SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040572 LIMIT 1 [ RunTime:0.001976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040572 [ RunTime:0.003073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735400,600018,746793,442992,315185,496460,141294,183525,775551,782341,475048,847844,300421,650399,114020,505721,346234,226610,188402,238528,1004301,494286,419980,802629,98904,299702,493663,331959,206881,586460,755778,186311,198641,556451,448532,310433,981707,633084,581500,220827,994599,779141,14626,470680,188892,191271,672142,442367,863782,600845,459715,858337,732368,548273,156155,443320,146558,899459,800904,273539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002157s ]