SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44887 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44887 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261919,635137,1036354,416240,265899,377265,129094,802004,906191,418435,53876,602426,88898,517821,981678,456539,192023,160419,899664,82340,1010936,753169,1027129,851213,775804,818778,877728,887959,8242,539787,684490,254112,479361,745576,189299,80789,774792,549436,512644,256363,232019,471107,783881,713878,271354,427324,224233,52940,966532,577600,76469,489637,416458,800657,71670,36468,472115,127041,973680,686941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]