SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421228 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421228 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696007,390839,588940,463999,548952,621195,91400,783932,1047606,749065,451350,947537,290562,936335,124344,950317,1029568,496945,216001,232328,442703,857950,1027384,479318,750076,698765,582170,81204,517502,755326,996480,752163,429506,533211,1026407,475698,832542,913106,595534,711960,790732,388783,956102,434418,6644,368801,572496,957393,945475,965741,261797,299999,821313,624082,733785,109617,941587,1042596,481681,762707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]