SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531121 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531121 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582787,606256,1015780,890340,594862,1029188,870788,14892,377499,895276,98319,880070,39466,261285,750702,582299,681502,305513,874900,433254,522520,854596,238251,919682,988188,281804,959254,354355,749016,174717,797230,920343,18482,183110,119975,367237,823155,773755,434386,415593,589788,5481,138923,407197,208015,705348,180526,811569,899234,979797,1048714,21992,668037,256471,1017647,602348,254173,638708,172719,13362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]