SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334801 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334801 [ RunTime:0.004000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226615,513381,14033,838289,674926,1033590,829463,26699,129623,215395,313631,1045479,947149,1011245,579509,503916,121015,583639,319014,189297,888447,129723,265156,370664,522733,621843,180601,371749,824634,418137,700739,900271,382416,502138,354215,788771,700202,505825,420814,907327,616050,622095,564447,314120,118667,94143,925640,105732,232937,664482,598704,703043,526663,429002,214955,762251,538519,185321,677278,810262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001521s ]