SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 647948 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 647948 [ RunTime:0.006796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425013,528169,646550,656203,196548,157675,845491,913438,663182,162068,677112,785383,129711,690895,267705,48529,509358,625149,1026946,895635,278519,1020493,179816,96944,1018988,23514,208495,860723,346302,621889,847661,292076,20250,795484,332639,125534,494114,762491,593008,385184,211331,779947,1031250,91460,116594,858861,684620,176906,207466,967782,586583,485636,960495,318000,968613,751209,1024271,175431,821849,802484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 647948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 647948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]