SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011988 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011988 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243170,155217,659238,898983,391335,262885,538608,561266,718864,34550,928034,855916,703241,256844,223629,379463,659922,25417,504019,652189,393368,529262,833850,1020583,731237,483116,574620,892792,582726,850982,1016762,806504,841120,252269,315137,927243,826116,590561,786296,979334,349912,1018703,759142,734622,473420,364303,650306,993637,720631,666578,687473,388835,829986,11445,650916,164634,540211,950545,616922,254992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]