SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456956 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456956 [ RunTime:0.004502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447033,836793,194028,737069,33938,993653,352596,751944,245264,534113,901852,410161,171438,672320,499079,170850,806747,121923,939834,811396,510781,488490,904190,72135,548494,865963,338879,506922,715452,990519,521856,548426,832543,780100,187326,945925,755487,512828,421127,24725,859010,516591,185428,126845,279420,392753,821129,416839,382343,775411,245573,703108,588537,852242,96199,490860,329023,736733,714575,952425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]