SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029860 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029860 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230727,770230,909476,877100,892626,647187,116013,350971,577490,36326,818196,1197,902286,615699,240593,1035500,967318,1006757,353843,501834,1044475,229776,977592,690447,925945,980322,273636,227530,5213,106977,709885,384927,253043,971757,650608,76817,129732,326872,836171,524426,93166,218222,908780,767363,445295,1041538,357070,654094,254468,679487,528375,542107,609940,231544,810123,66400,284783,478126,591173,987992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]