SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541998 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541998 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960611,534403,985499,78501,197167,28968,297950,1021364,905236,502001,991807,114843,85230,594048,377663,6003,489548,249111,750459,627485,97991,851065,913739,861827,263678,944470,538395,851080,637330,825084,117905,629627,521219,177147,510040,47282,829180,466473,822311,189596,5508,129636,529136,944374,430692,495393,890308,144129,220390,781657,362338,237907,399804,831006,339421,495922,185344,374837,341675,43908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]