SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019016 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019016 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798714,874770,805705,1019702,598439,24089,114979,796688,893084,123383,93520,712051,715286,1002563,697966,778675,348657,399500,403940,6275,885829,168961,53790,375467,385528,402577,871172,376108,144242,951589,617195,281056,259864,657726,1002946,962447,613328,745336,334131,544030,148265,1047539,544780,756814,588228,195484,165244,781055,1015127,682808,336234,292354,685979,644590,1025162,770957,890429,491063,907788,276199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]