SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120415 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120415 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462260,945882,778830,191401,446932,820273,54301,266982,515999,1016562,1035608,1029251,379876,480527,139013,377031,218709,725292,714355,829074,798790,528053,902129,294557,230479,75142,827455,273609,240093,825296,243399,600529,534564,334296,688294,35873,153156,213327,966238,251488,670637,507769,835667,568584,559494,113549,769367,457390,82116,287728,251497,841845,354868,797374,906123,425217,924148,518503,676562,460993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]