SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567621 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567621 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005790,26797,638457,652618,79873,806022,214570,666357,169510,499788,561566,181193,832026,451456,1001295,377605,161233,603286,87949,415812,919807,234893,787248,182916,155154,674790,261995,573851,82836,264499,173912,334256,237950,511388,535155,47469,49122,26640,846359,316566,312918,278559,470058,926087,243317,928181,309632,668599,530651,242344,553085,734940,761151,712498,849292,315539,950854,958069,531341,644235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]