SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567215 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567215 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565228,179298,842103,859135,687998,941381,134209,433871,31025,567821,695054,376532,385562,44276,880302,219379,855596,461736,447205,932773,949271,722797,131087,898577,417599,879796,682261,988063,941747,781722,862151,594517,6899,744690,192939,978204,782011,836689,58399,669052,766858,754393,308117,457722,76906,907356,247873,444973,120045,572113,721646,165154,702274,760988,35989,215026,12000,290885,375837,691258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]