SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533103 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533103 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32028,693046,1024781,311467,160898,350634,876080,847658,681472,1041726,980310,995225,134076,318243,756072,441115,971084,522183,944926,201280,583846,995753,890308,624370,472990,144495,912043,775211,231094,767165,387978,1017460,90581,939324,344362,25104,396777,1000344,754476,1040890,354417,967244,357699,879352,861746,89876,480679,1021290,963619,136382,540394,205789,548112,242132,977181,211148,338911,965801,100101,351376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]